package com.hna.eking.AirGisPlt.MybatisImp;
import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import com.hna.eking.AirGisPlt.Mapper.MapStarFeatureMapper;
public interface MapStarFeature {
	@Select("select * from MapStarFeature where AirportCode = #{AirportCode}")
	public List<MapStarFeatureMapper> getByAirportCode(String AirportCode);
	
	@Insert("insert into MapStarFeature values(#{AirportCode}, #{FeatType}, #{StartFlag}, #{Angle}, #{Length}, #{MaxSpeed}, " + 
			"#{Elev}, #{Aist}, #{AistCode}, #{LineGeo})")
	public int InsertMapStarInfo(MapStarFeatureMapper MapFeatInfo);	
	
	@Delete("delete from MapStarInfo where AirportCode = #{AirportCode}")
	public int DeleteMapStarInfo(String AirportCode);
	
	@Update("update MapStarFeature set FeatType = #{FeatType}, IndCode = #{StartFlag}," + 
			"Angle = #{Angle}, Length = #{Length}, MaxSpeed = #{MaxSpeed}" + 
			"Elev = #{Elev}, Aist = #{Aist}, AistCode = #{AistCode}, LineGeo = #{LineGeo},"  + 
			"where AirportCode = #{AirportCode}")
	public int UpdatebyAirlineCode(MapStarFeatureMapper MapFeatInfo);
}
